Hcl interview

1st round written exam
Prgma autonomous 
Bitmap index
Cursor 
How will delete duplicates record

1st round ques
1.write the query to delete the duplicates 
2.diff b/w B*tree index and Bit Map index
3.write the procedure using pragma autonomous transaction
4.write the procedure with using multiple cursor